﻿using DAL;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;


namespace MGLibrarySystem.DAL
{
    public class BookManage
    {
        public DataTable GetBookManage()
        {

            string sql = "select BookID'图书ID', BookName'图书名称', BookAuthor'图书作者', BookPrice'图书价格', BookNumber'图书编号', BookType'图书类型',(CASE WHEN BookState=1 THEN '已借出' ELSE '未借出' END ) '图书状态' from bookManage";
           return SqlHelper.ExecuteDataTable(sql);
        }

    }   
    
}
